Model Table CUSTOMER ADDRESS

Attributes

Attribute Description (where applicable)
CountryCustomer Country
Customer CodeCustomer Code
Geo AddressCustomer Address - Built as Street Address, City, Country
Geo CityBuilt as City, Country
Jurisdiction CodeCode of jurisdiction, when applicable

Hierarchies

Hierarchy Level
CustAddressHy
Country
Geo City
Geo Address

USED BY MODEL(S)

Model Name
Sales

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table DW Source view (SQL Server) BI Access View Referenced Information Source Recommended Access Type
CUSTOMER ADDRESSDIM_CUSTOMER_INFO_ADDRESS_SALES_TMDIM_CUSTOMER_INFO_ADDRESS_BIDIM_CUSTOMER_INFO_ADDRESSOn Line